{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Agi Example","Fruit Example","Coffee Example","Coffee example Pareto","Fruit Example with pareto","Blank Waste Walk","Blank Pareto Analysis"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Agi Example","index":0,"n_rows":76,"n_cols":19,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Process Step","Waste Walk/Activity","Individual time (mins)","Number of times done per week","Culmulative minutes","VA or NVA","Value Added per event","NVA per event","Average Distance per event"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",{"$nulls":4},"mins","mins","mtrs"]
[1,"Scraping tops",5,{"$f":"7*2*7","v":98},{"$f":"D3*C3","v":490},"va",5,0,{"$f":"50*2+35","v":135}," ",null,null,1,{"$nulls":5},"Lots of walking to find scraper"]
[2,"Sanding cubicles",15,{"$f":"5*2.5","v":12.5},{"$f":"D4*C4","v":187.5},"va",15,0,{"$f":"70*2*5","v":700}," ",null,1,1,{"$nulls":5},"Don't know when and how much"]
[3,"Moving cows to collecting yard",10,{"$f":"6*2*7","v":84},840,"nva",0,10,180," ",1,null,1,1]
[4,"Returning cows from collecting yard",10,{"$f":"4*2*7","v":56},560,"nva",0,10,180," ",1,null,1,1,{"$nulls":4},"Yard 1&2 go back on their own"]
[5,"Moving dry cows from cubicles and back",10,14,{"$f":"D7*C7","v":140},"nva",0,10,{"$f":"60*6","v":360}," ",1,null,1,{"$nulls":5},"Lots of moving cows about"]
[6,"Scraping feed passages",3,{"$f":"5*2*7","v":70},210,"va",3,0,{"$f":"50*3","v":150}," ",1,null,1]
[7,"Scraping cubicle passages",5,{"$f":"5*2*7","v":70},350,"va",5,0,{"$f":"50*7","v":350}," ",1,null,1]
[8,"Raking sand beds",12,{"$f":"5*2*7","v":70},840,"va",10,0,{"$f":"50*2","v":100}," ",null,null,1,null,null,1,null,null,"Danger of \"over-doing beds\".  They must be clean but don't need to be pretty"]
[9,"Stalosaning/liming beds",5,{"$f":"5*2","v":10},50,"va",5,0,150," ",null,1,1,{"$nulls":5},"Control of amount of stalosan & lime used, could see savings. SBP note?"]
[10,"Sawdusting yard 3 & 4",10,7,70,"va",10,0,{"$f":"6*36*2+50","v":482}," ",1,1,1,{"$nulls":5},"Lots of walking to get sawdust bags"]
[11,"Brushing & Cleaning yard 3 & 4",5,14,70,"va",5,0,{"$f":"36*4","v":144}," ",null,null,1,null,null,1,null,null,"OK if brush is not broken and in right place"]
[12,"Returning AI cows to cubicles",15,7,{"$f":"D14*C14","v":105},"nva",0,15,{"$f":"75*4*2","v":600}," ",1,null,1,{"$nulls":5},"Don't know which cows go to which yards"]
[15,"Emptying Water troughs",5,14,70,"va",1,3,null," ",{"$nulls":8},"Yard 3 & 4 are difficult.  Not tip-over troughs"]
[16,"Footbathing",{"$f":"(10*2+20)","v":40},3,120,"va",null,40,{"$f":"400+200","v":600}," ",null,null,1,1,{"$nulls":4},"Quite disrupting of normal routine"]
[17,"Pushing food up",15,7,105,"nva",7,8,500," ",null,null,1,{"$nulls":5},"Just another job"]
[18,"Scraping out cubicle & dispersal yard etc",15,{"$f":"2*7","v":14},210,"nva",1,14,500," ",1,null,1]
[" ",null,null,null,0,{"$nulls":4}," "]
[{"$nulls":4},0,{"$nulls":4}," "]
[{"$nulls":4},0,{"$nulls":4}," "]
[null,"Totals",null,null,{"$f":"SUM(E3:E21)","v":4417.5},null,null,null,{"$f":"SUM(I3:I21)","v":5131}]
[]
[null,"Total time allocated"]
[null,"Morning",{"$f":"6*60","v":360},7,{"$f":"D25*C25","v":2520},null,null,null,"NVA Hrs"]
[null,"Afternoon",{"$f":"4*60","v":240},7,{"$f":"D26*C26","v":1680}]
[{"$nulls":8},"NVA %"]
[{"$nulls":4},{"$f":"SUM(E25:E27)","v":4200},null,null,null,"VA %"]
[]
[{"$nulls":4},{"$f":"E22/E28","v":1.0517857142857143}]
{"$rows_empty":27}
["Process Step","Waste Walk/Activity","Process Step","Pareto Individual ","Pareto Cumulative"]
[3,"Moving cows to collecting yard",3,0.19015280135823429,{"$f":"D59","v":0.19015280135823429}]
[8,"Raking sand beds",8,0.19015280135823429,{"$f":"E59+D60","v":0.38030560271646857}]
[4,"Returning cows from collecting yard",4,0.12676853423882287,{"$f":"E60+D61","v":0.50707413695529147}]
[1,"Scraping tops",1,0.11092246745897001,0.61799660441426152]
[7,"Scraping cubicle passages",7,7.9230333899264288E-2,0.69722693831352578]
[6,"Scraping feed passages",6,4.7538200339558571E-2,0.74476513865308436]
[18,"Scraping out cubicle & dispersal yard etc",18,4.7538200339558571E-2,0.79230333899264294]
[2,"Sanding cubicles",2,4.2444821731748725E-2,0.83474816072439162]
[5,"Moving dry cows from cubicles and back",5,3.1692133559705717E-2,0.8664402942840973]
[16,"Footbathing",16,2.7164685908319185E-2,0.89360498019241652]
[12,"Returning AI cows to cubicles",12,2.3769100169779286E-2,0.91737408036219581]
[17,"Pushing food up",17,2.3769100169779286E-2,0.9411431805319751]
[10,"Sawdusting yard 3 & 4",10,1.5846066779852858E-2,0.956989247311828]
[11,"Brushing & Cleaning yard 3 & 4",11,1.5846066779852858E-2,0.97283531409168089]
[15,"Emptying Water troughs",15,1.5846066779852858E-2,0.98868138087153379]
[9,"Stalosaning/liming beds",9,1.1318619128466326E-2,1.0000000000000002]
[13,"Reporting Bulling cows",13,0]
[14,"Checking Calving cows",14,0]

{"sheet":"Fruit Example","index":1,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,2,24,3],[25,2,25,3],[25,7,25,8],[25,9,25,14],[26,2,26,3],[26,7,26,8],[26,9,26,14]]}
["Process Step","Waste Walk/Activity","VA or NVA","Step Time","No. of times done per week","Cumulative Time","Distance","Pareto Ranking","Pareto Individual ","Pareto Cumulative"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",null,"mins",null,"mins","mtrs",null,"%","%"]
[1,"Generate Volume Estimates","NVA",30,1,{"$f":"SUM(D3*E3)","v":30},0,null,{"$f":"SUM(F3/$F$23)","v":2.6898471718498527E-5}]
[2,"Create Job Plan (3 people)","NVA",30,5,150,0,null,1.3449235859249264E-4,{"$nulls":7},"x"]
[3,"Distribute Job Plan to relevant personnel","NVA",15,5,75,3000,null,6.724617929624632E-5,{"$nulls":4},"x"]
[4,"Transport Staff to Field (120 people)","NVA",10,5,50,1000,null,4.4830786197497542E-5,{"$nulls":4},"x"]
[5,"Staff store belongings and collect trollies (120 people)","NVA",2,600,1200,200,null,1.0759388687399411E-3,{"$nulls":4},"x"]
[6,"Staff Collect Trays & Punnets","NVA",2,600,1200,200,null,1.0759388687399411E-3,null,null,"x"]
[7,"Supervisor Allocates Rows","NVA",5,200,1000,0,null,8.966157239499509E-4]
[8,"Picking 1 Full Trolley","VA",90,{"$f":"(600*20)","v":12000},1080000,300,null,0.96834498186594697]
[9,"Take trolley to scan station","NVA",0.5,{"$f":"(600*20)","v":12000},6000,20,null,5.3796943436997058E-3,{"$nulls":4},"x"]
[10,"Place trays on Scan Station","NVA",0.5,{"$f":"(600*20)","v":12000},6000,0,null,5.3796943436997058E-3,{"$nulls":4},"x"]
[11,"Stick Picker No on Trays if leaving trolley","NVA",0.5,{"$f":"(600*20)","v":12000},6000,0,null,5.3796943436997058E-3]
[12,"Spot check weights/ QC check","NVA",0.5,200,100,0,null,8.9661572394995084E-5,{"$nulls":7},"x"]
[13,"Data Entry on Tablet","NVA",0.5,{"$f":"(600*20)","v":12000},6000,0,null,5.3796943436997058E-3]
[14,"Trays to Fridge","NVA",0.5,{"$f":"(600*20)","v":12000},6000,5,null,5.3796943436997058E-3,null,null,"x"]
[15,"Fridge to Packhouse","NVA",15,100,1500,1000,null,1.3449235859249265E-3,null,null,"x"]
[]
[]
[]
[]
[]
[null,"Totals:",null,{"$f":"SUM(D3:D22)","v":202},null,{"$f":"SUM(F3:F22)","v":1115305}]
[]
[null,"Total Time",{"$f":"SUM(F23)","v":1115305}]
[null,"Total VA",{"$f":"(F10)","v":1080000},null,null,null,"%VA",{"$f":"(C26/C25)","v":0.96834498186594697},null," (Total VA/Total Time X 100)"]
[null,"Total NVA",{"$f":"SUM(C25-C26)","v":35305},null,null,null,"%NVA",{"$f":"(C27/C25)","v":3.1655018134053019E-2},null," (Total NVA/Total Time X 100)"]
[]
[]
[]
[]
[{"$nulls":9}," "]

{"sheet":"Coffee Example","index":2,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,2,19,3],[20,2,20,3],[20,7,20,8],[20,9,20,14],[21,2,21,3],[21,7,21,8],[21,9,21,14]]}
["Process Step","Waste Walk/Activity","VA or NVA","Step Time","No. of times done per day","Cumulative Time","Distance","Pareto Ranking","Pareto Individual ","Pareto Cumulative"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",null,"secs",null,"secs","mtrs",null,"%","%"]
[1,"Customer queing time","NVA",113,1500,{"$f":"(E3*D3)","v":169500},4,1,{"$f":"SUM(F3/$F$18)","v":0.551219512195122},{"$nulls":4},"x","x",null,null,null,"x"]
[2,"Greet customer & take the order ","VA",5,2000,10000,0,6,3.2520325203252036E-2]
[3,"Heat/cup glass","NVA",13,500,6500,2,9,2.113821138211382E-2,null,null,"x",null,"x",null,null,"x"]
[4,"Prepare milk","NVA",25,500,12500,1,5,4.065040650406504E-2,null,null,"x",null,"x"]
[5,"Prepare coffee shots","NVA",12,500,6000,3,10,1.9512195121951219E-2,null,null,"x",null,"x","x"]
[6,"Heat milk","NVA",41,500,20500,2,3,6.6666666666666666E-2,null,null,"x",null,"x",null,"x"]
[7,"Build drink","NVA",17,500,8500,3,7,2.7642276422764227E-2,null,null,"x",null,"x","x"]
[8,"Take drink to coffee pick-up point","NVA",4,2000,8000,5,8,2.6016260162601626E-2,null,null,"x",null,"x"]
[9,"Serve drink to the customer ","VA",7,2000,14000,4,4,4.5528455284552849E-2,{"$nulls":4},"x"]
[10,"Take payment ","VA",26,2000,52000,1,2,0.16910569105691056,{"$nulls":4},"x","x"]
[11]
[]
[]
[]
[]
[null,"Totals:",null,{"$f":"SUM(D3:D13)","v":263},null,{"$f":"SUM(F3:F17)","v":307500}]
[]
[null,"Total Time",{"$f":"(F18)","v":307500}]
[null,"Total VA",{"$f":"SUM(F4+F11+F12)","v":76000},null,null,null,"%VA",{"$f":"(C21/C20)","v":0.24715447154471545},null," (Total VA/Total Time X 100)"]
[null,"Total NVA",{"$f":"SUM(C20-C21)","v":231500},null,null,null,"%NVA",{"$f":"(C22/C20)","v":0.75284552845528452},null," (Total NVA/Total Time X 100)"]
[]
[]
[]
[]
[{"$nulls":9}," "]

{"sheet":"Coffee example Pareto","index":3,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Process Step","Waste Walk/Activity","VA or NVA","Step Time","No. of times done per day","Cumulative Time","Distance","Pareto Ranking","Pareto Individual ","Pareto Cumulative"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",null,"secs",null,"secs","mtrs",null,"%","%"]
[1,"Customer queing time","NVA",113,1500,{"$f":"(E3*D3)","v":169500},4,1,{"$f":"SUM(F3/$F$18)","v":0.551219512195122},{"$f":"SUM(I3)","v":0.551219512195122},null,null,null,"x","x",null,null,null,"x"]
[2,"Take payment ","VA",26,2000,52000,1,2,0.16910569105691056,{"$f":"SUM($I$3:I4)","v":0.72032520325203253},null,null,null,"x","x"]
[3,"Heat milk","NVA",41,500,20500,2,3,6.6666666666666666E-2,{"$f":"SUM($I$3:I5)","v":0.78699186991869918},null,"x",null,"x",null,"x"]
[4,"Serve drink to the customer ","VA",7,2000,14000,4,4,4.5528455284552849E-2,{"$f":"SUM($I$3:I6)","v":0.83252032520325203},null,null,null,"x"]
[5,"Prepare milk","NVA",25,500,12500,1,5,4.065040650406504E-2,{"$f":"SUM($I$3:I7)","v":0.87317073170731707},null,"x",null,"x"]
[6,"Greet customer & take the order ","VA",5,2000,10000,0,6,3.2520325203252036E-2,{"$f":"SUM($I$3:I8)","v":0.90569105691056906}]
[7,"Build drink","NVA",17,500,8500,3,7,2.7642276422764227E-2,{"$f":"SUM($I$3:I9)","v":0.93333333333333324},null,"x",null,"x","x"]
[8,"Take drink to coffee pick-up point","NVA",4,2000,8000,5,8,2.6016260162601626E-2,{"$f":"SUM($I$3:I10)","v":0.95934959349593485},null,"x",null,"x"]
[9,"Heat/cup glass","NVA",13,500,6500,2,9,2.113821138211382E-2,{"$f":"SUM($I$3:I11)","v":0.98048780487804865},null,"x",null,"x",null,null,"x"]
[10,"Prepare coffee shots","NVA",12,500,6000,3,10,1.9512195121951219E-2,{"$f":"SUM($I$3:I12)","v":0.99999999999999989},null,"x",null,"x","x"]
[11]
[]
[]
[]
[]
[null,"Totals:",null,{"$f":"SUM(D3:D17)","v":263},null,{"$f":"SUM(F3:F17)","v":307500}]
{"$rows_empty":8}
[{"$nulls":9}," "]

{"sheet":"Fruit Example with pareto","index":4,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,2,24,3],[25,2,25,3],[25,6,25,7],[25,8,25,13],[26,2,26,3],[26,6,26,7],[26,8,26,13]]}
["Process Step","Waste Walk/Activity","VA or NVA","Step Time","Cumulative Time","Distance","Pareto Ranking","Pareto Individual ","Pareto Cumulative"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",null,"mins","mins","mtrs",null,"%","%"]
[8,"Picking 1 Full Trolley","VA",90,null,300,null,{"$f":"SUM(D3/$C$25)","v":0.44554455445544555},{"$f":"SUM(H3)","v":0.44554455445544555}]
[1,"Generate Volume Estimates","NVA",30,null,0,null,0.14851485148514851,{"$f":"SUM($H$3:H4)","v":0.59405940594059403}]
[2,"Create Job Plan (3 people)","NVA",30,null,0,null,0.14851485148514851,{"$f":"SUM($H$3:H5)","v":0.74257425742574257},{"$nulls":6},"x"]
[3,"Distribute Job Plan to relevant personnel","NVA",15,null,3000,null,7.4257425742574254E-2,{"$f":"SUM($H$3:H6)","v":0.81683168316831678},null,null,null,"x"]
[15,"Fridge to Packhouse","NVA",15,null,1000,null,7.4257425742574254E-2,{"$f":"SUM($H$3:H7)","v":0.89108910891089099},null,"x"]
[4,"Transport Staff to Field (120 people)","NVA",10,null,1000,null,4.9504950495049507E-2,{"$f":"SUM($H$3:H8)","v":0.94059405940594054},null,null,null,"x"]
[7,"Supervisor Allocates Rows","NVA",5,null,0,null,2.4752475247524754E-2,{"$f":"SUM($H$3:H9)","v":0.96534653465346532}]
[5,"Staff store belongings and collect trollies (120 people)","NVA",2,null,200,null,9.9009900990099011E-3,{"$f":"SUM($H$3:H10)","v":0.97524752475247523},null,null,null,"x"]
[6,"Staff Collect Trays & Punnets","NVA",2,null,200,null,9.9009900990099011E-3,{"$f":"SUM($H$3:H11)","v":0.98514851485148514},null,"x"]
[9,"Take trolley to scan station","NVA",0.5,null,20,null,2.4752475247524753E-3,{"$f":"SUM($H$3:H12)","v":0.98762376237623761},null,null,null,"x"]
[10,"Place trays on Scan Station","NVA",0.5,null,0,null,2.4752475247524753E-3,{"$f":"SUM($H$3:H13)","v":0.99009900990099009},null,null,null,"x"]
[11,"Stick Picker No on Trays if leaving trolley","NVA",0.5,null,0,null,2.4752475247524753E-3,{"$f":"SUM($H$3:H14)","v":0.99257425742574257}]
[12,"Spot check weights/ QC check","NVA",0.5,null,0,null,2.4752475247524753E-3,{"$f":"SUM($H$3:H15)","v":0.99504950495049505},{"$nulls":6},"x"]
[13,"Data Entry on Tablet","NVA",0.5,null,0,null,2.4752475247524753E-3,{"$f":"SUM($H$3:H16)","v":0.99752475247524752}]
[14,"Trays to Fridge","NVA",0.5,null,5,null,2.4752475247524753E-3,{"$f":"SUM($H$3:H17)","v":1},null,"x"]
[]
[]
[]
[]
[]
[null,"Totals:"]
[]
[null,"Total Time",{"$f":"SUM(D3:D23)","v":202}]
[null,"Total VA",90,null,null,"%VA",{"$f":"(C26/C25)","v":0.44554455445544555},null," (Total VA/Total Time X 100)"]
[null,"Total NVA",{"$f":"SUM(C25-C26)","v":112},null,null,"%NVA",{"$f":"(C27/C25)","v":0.5544554455445545},null," (Total NVA/Total Time X 100)"]
[]
[]
[]
[]
[{"$nulls":8}," "]

{"sheet":"Blank Waste Walk","index":5,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,2,19,3],[20,2,20,3],[20,7,20,8],[20,9,20,14],[21,2,21,3],[21,7,21,8],[21,9,21,14]]}
["Process Step","Waste Walk/Activity","VA or NVA","Step Time","No. of times done per day","Cumulative Time","Distance","Pareto Ranking","Pareto Individual ","Pareto Cumulative"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",null,"secs",null,"secs","mtrs",null,"%","%"]
[1,{"$nulls":4},{"$f":"(E3*D3)","v":0},null,null,{"$f":"SUM(F3/$F$18)","v":{"$error":"#DIV/0!"}}]
[2,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[3,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[4,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[5,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[6,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[7,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[8,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[9,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[10,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"}]
[11]
[]
[]
[]
[]
[null,"Totals:",null,{"$f":"SUM(D3:D13)","v":0},null,{"$f":"SUM(F3:F17)","v":0}]
[]
[null,"Total Time",{"$f":"(F18)","v":0}]
[null,"Total VA",{"$f":"SUM(F4+F11+F12)","v":0},null,null,null,"%VA",{"$f":"(C21/C20)","v":{"$error":"#DIV/0!"}},null," (Total VA/Total Time X 100)"]
[null,"Total NVA",{"$f":"SUM(C20-C21)","v":0},null,null,null,"%NVA",{"$f":"(C22/C20)","v":{"$error":"#DIV/0!"}},null," (Total NVA/Total Time X 100)"]
[]
[]
[]
[]
[{"$nulls":9}," "]

{"sheet":"Blank Pareto Analysis","index":6,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,2,19,3],[20,2,20,3],[20,7,20,8],[20,9,20,14],[21,2,21,3],[21,7,21,8],[21,9,21,14]]}
["Process Step","Pareto Analysis","VA or NVA","Step Time","No. of times done per day","Cumulative Time","Distance","Pareto Ranking","Pareto Individual ","Pareto Cumulative"," ","Transportation","Inventrory","Movement ","Waiting & Delays","Overproduction","Overprocessing","Defects  & Rework","Skills & Talent","Remarks"]
[null," ",null,"secs",null,"secs","mtrs",null,"%","%"]
[1,{"$nulls":4},{"$f":"(E3*D3)","v":0},null,null,{"$f":"SUM(F3/$F$18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I3)","v":{"$error":"#DIV/0!"}}]
[2,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I4)","v":{"$error":"#DIV/0!"}}]
[3,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I5)","v":{"$error":"#DIV/0!"}}]
[4,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I6)","v":{"$error":"#DIV/0!"}}]
[5,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I7)","v":{"$error":"#DIV/0!"}}]
[6,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I8)","v":{"$error":"#DIV/0!"}}]
[7,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I9)","v":{"$error":"#DIV/0!"}}]
[8,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I10)","v":{"$error":"#DIV/0!"}}]
[9,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I11)","v":{"$error":"#DIV/0!"}}]
[10,{"$nulls":4},0,null,null,{"$error":"#DIV/0!"},{"$f":"SUM($I$3:I12)","v":{"$error":"#DIV/0!"}}]
[11]
[]
[]
[]
[]
[null,"Totals:",null,{"$f":"SUM(D3:D13)","v":0},null,{"$f":"SUM(F3:F17)","v":0}]
[]
[null,"Total Time",{"$f":"(F18)","v":0}]
[null,"Total VA",{"$f":"SUM(F4+F11+F12)","v":0},null,null,null,"%VA",{"$f":"(C21/C20)","v":{"$error":"#DIV/0!"}},null," (Total VA/Total Time X 100)"]
[null,"Total NVA",{"$f":"SUM(C20-C21)","v":0},null,null,null,"%NVA",{"$f":"(C22/C20)","v":{"$error":"#DIV/0!"}},null," (Total NVA/Total Time X 100)"]
[]
[]
[]
[]
[{"$nulls":9}," "]